UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcPm23e4MjGQ6N/WCOPl4TTJaZS582Bmgxon0jbRX+g='
WHERE
key_id = '6c2742eb84012e660c648a8d10aa0f0d7902a162d0099b63999979de65fa0595'
AND (
token = 'bcPm23e4MjGQ6N/WCOPl4TTJaZS582Bmgxon0jbRX+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)