UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'loW+nPa0MOsZcDQ58oquaCXm5WfsmxNyLNIqy8frabc='
WHERE
key_id = 'b049f4337549cffa434beb2d0e2a0c184a525d4023b303520e46932d2e28990e'
AND (
token = 'loW+nPa0MOsZcDQ58oquaCXm5WfsmxNyLNIqy8frabc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)