UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qG2+4uW8SX+f9q9eW77sKcBVDgJG0OmK1MylUC1OseI='
WHERE
key_id = '388857d36e13546c8101f8613dd9dd1565b07d45d605183c6839ee9d652ce754'
AND (
token = 'qG2+4uW8SX+f9q9eW77sKcBVDgJG0OmK1MylUC1OseI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)