UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6q9paZMGDnyxpD2BmVQ3fSbwAaxNqEieg5Qs/8fWQQA='
WHERE
key_id = '0db33b8a5ee5e72752f788eb7b674fe53e84ced9c438bf753261c4d63f919fc2'
AND (
token = '6q9paZMGDnyxpD2BmVQ3fSbwAaxNqEieg5Qs/8fWQQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)