UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WRRdiHeQgGcwartdkBJ86QkXJOHfPKKUQwO+V/24Uc='
WHERE
key_id = '5745687a24fb2886831f83a8469d638aa6d8cee2eb08a2175a27ce1563ecbd12'
AND (
token = '0WRRdiHeQgGcwartdkBJ86QkXJOHfPKKUQwO+V/24Uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)