UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7X/s4Tv7ogYhZT4vnfeEM0XEwzOfTEY5B5kcJ79XJUg='
WHERE
key_id = 'f502d270c684d3f4e90890d685c2e2df8b993cb5bd178be3f39c2efd215845c8'
AND (
token = '7X/s4Tv7ogYhZT4vnfeEM0XEwzOfTEY5B5kcJ79XJUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)