UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgttUqgy1mUCQvYUY68aSlwCSm/j+Jjdzq1LByNByYY='
WHERE
key_id = '1e09109ddf3dc78f82b6230f891a77d456fd141ffc4d702f2e2bae3bc06a41f0'
AND (
token = 'tgttUqgy1mUCQvYUY68aSlwCSm/j+Jjdzq1LByNByYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)