UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PR6qcAl9zUXC1hgdfvQXjYUKn7CbAACEGlnED0+pE/w='
WHERE
key_id = '4612177af72a3f757ed1deafc8a07b7cb9bb70a009bafaea448e318a1656ea50'
AND (
token = 'PR6qcAl9zUXC1hgdfvQXjYUKn7CbAACEGlnED0+pE/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)