UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tia8kXMqdIJ6OefvcHDKhKKbrGQygydmJ4nNMgc73Us='
WHERE
key_id = '85842459b0185e156667e13d190a34287a8efae535eaa5c45a01405030f6ff46'
AND (
token = 'Tia8kXMqdIJ6OefvcHDKhKKbrGQygydmJ4nNMgc73Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)