UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sVgVOVHVHV9tbdx/TsWJPbz9kxyzg6NR8mLqGMWn/Zw='
WHERE
key_id = '561167512286a6d22be49a3a3916ca8b2e1481f03fd356b7f03ff23b45ea0040'
AND (
token = 'sVgVOVHVHV9tbdx/TsWJPbz9kxyzg6NR8mLqGMWn/Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)