UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oD7oVVjeZnRF1v0Gziu+zUPpvTIZFpdRQUEBtHJLZek='
WHERE
key_id = 'cb6b62ddc48593c5769c980a2a799c0e8ca3a92961a80e70870e5cdb2f3f5073'
AND (
token = 'oD7oVVjeZnRF1v0Gziu+zUPpvTIZFpdRQUEBtHJLZek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)