UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IsFvwxt1FGnOdRai27OEKp+WDBZZwR6aK9NO4vN/2oI='
WHERE
key_id = 'ec20322fac6093faa7cda1133e7886269eadfd4c31f111283a7164d8c7c84771'
AND (
token = 'IsFvwxt1FGnOdRai27OEKp+WDBZZwR6aK9NO4vN/2oI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)