UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y55R8f40pzSjSUwgkaOlXMHG1ri2AymeCj+KfUmLBnw='
WHERE
key_id = 'be397ccf971c98716cc3ef70dc83f408016f9765b5e2cb7e19d646ee385829a1'
AND (
token = 'Y55R8f40pzSjSUwgkaOlXMHG1ri2AymeCj+KfUmLBnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)