UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S19UzKSDflS9LH4ZvOnkUzwcHEvS1j4HyXB9FFTBpqc='
WHERE
key_id = '9550c94cbb6f4df292a104b0b2072f3c558f39cfd46bc8c6ac195b392371eb5a'
AND (
token = 'S19UzKSDflS9LH4ZvOnkUzwcHEvS1j4HyXB9FFTBpqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)