UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J987PCJR7fk9LdQGrAFih0MB3CLZEUqEsowsn6ZjfkM='
WHERE
key_id = '8123d073546d3a2a6e41fe202990f447f8a1150c4ee8d0b009a3d8123bc2977c'
AND (
token = 'J987PCJR7fk9LdQGrAFih0MB3CLZEUqEsowsn6ZjfkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)