UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTZUb1jqSDUozJW9QPghZQOwCqebyVBwIrZn3StRM4w='
WHERE
key_id = '591e4c16000da22ea13d14c3c4c8274da264d4873befdec0620ea549261a6ab1'
AND (
token = 'bTZUb1jqSDUozJW9QPghZQOwCqebyVBwIrZn3StRM4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)