UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pwpNw1PXCnhke2pvLmVtQ8+1+LVHnaKmamH0Xu47G3A='
WHERE
key_id = 'b8d6909f4ec392403240b3c2455e7410146b7df027c3b74d453ee3da2ed12ed0'
AND (
token = 'pwpNw1PXCnhke2pvLmVtQ8+1+LVHnaKmamH0Xu47G3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)