UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+gPX6Xv01pQ2G0dbsIBV72csdiZHpvV1BOiS9W3jmyk='
WHERE
key_id = '894e4cdb49ffba221922e1f2d60f868d779d538d39d8fc123843e445b5c2306c'
AND (
token = '+gPX6Xv01pQ2G0dbsIBV72csdiZHpvV1BOiS9W3jmyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)