UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJysFVJbXxxAZ4b3LB5LM3hNSQyAA91/Is3CXpi9NQw='
WHERE
key_id = '9bdfba72f78fd88791bda5173aa95051106f7efe71062d1f2d78f1a1665d2ebb'
AND (
token = 'DJysFVJbXxxAZ4b3LB5LM3hNSQyAA91/Is3CXpi9NQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)