UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1J0R/VpCRVZ5pZRAZyA8CEvikl8PpW0SQoSUzL/CnE='
WHERE
key_id = '9ed6992c8ea2ce7fd062e25ad84d8f23ddbc81ee75d330dadb9fac577609e188'
AND (
token = 'c1J0R/VpCRVZ5pZRAZyA8CEvikl8PpW0SQoSUzL/CnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)