UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6RI55GAXQ8Pvff4qIJ6d7Q0P3gt01T4Lv5UKlfWj+lg='
WHERE
key_id = '6be9bc315c416f53149d74977feb7b231b9b4597a533ad985a5be869302989ce'
AND (
token = '6RI55GAXQ8Pvff4qIJ6d7Q0P3gt01T4Lv5UKlfWj+lg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)