UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+lrUKJMZlapfHePOb4pizLDK5xhrGvKhbe70EKer0A='
WHERE
key_id = '840ae1e4109f924d1ffae652584a59082bdbbf8feea3766f9c31acdf11a0afaa'
AND (
token = '6+lrUKJMZlapfHePOb4pizLDK5xhrGvKhbe70EKer0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)