UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZfSM8I16K5T7TyjfnjB2i9l7AyGS0ApGmITjECGcxE='
WHERE
key_id = '11ff730a270e80ea5a91123f2214e75c2fb194d56d9c6d92458088fca7437454'
AND (
token = 'yZfSM8I16K5T7TyjfnjB2i9l7AyGS0ApGmITjECGcxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)