UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ch7OEhU3pt6VfmHVjqfHn622jy1f1P3s+UqFIfF/Yg='
WHERE
key_id = 'e228d722b5fed6fd114f88cc0246d2693d70629a87c9a0b951c6b45a001498a9'
AND (
token = '+ch7OEhU3pt6VfmHVjqfHn622jy1f1P3s+UqFIfF/Yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)