UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7QgcGxHcy9N/b+/3ITOXryd36AUVFaT++DgAp+PdV6A='
WHERE
key_id = 'cbdd9e9a47be49d05a19c4544a5b2bf6682687f772b5258a981c5aab6e688953'
AND (
token = '7QgcGxHcy9N/b+/3ITOXryd36AUVFaT++DgAp+PdV6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)