UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hczKeZ+lVVMfY9lu3FKNR10fyq3u6GQGLkqphd/4C4='
WHERE
key_id = '65b218698767c1471a39fb9a1225a3930150aaf24fb72c2344936e52245338bf'
AND (
token = '3hczKeZ+lVVMfY9lu3FKNR10fyq3u6GQGLkqphd/4C4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)