UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1bGsK1N+gOHGUQr1dcSpEAl0u8mq1+HXBeMG0JA5dJU='
WHERE
key_id = '8a3f5c21acaa28364dced54802e31aa6da6e87b9fb82f168b750c1ae8c136c8a'
AND (
token = '1bGsK1N+gOHGUQr1dcSpEAl0u8mq1+HXBeMG0JA5dJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)