UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YZbcqDnZuaqp2eq71g/2gPIo/QwLUENZY6JDodKG7Os='
WHERE
key_id = 'a20dd15b06b025c630ac04a8d38304b5994171a59101c397440a284253fee5a9'
AND (
token = 'YZbcqDnZuaqp2eq71g/2gPIo/QwLUENZY6JDodKG7Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)