UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/EC+IUiOEfi1I/fHINWboPAtubr3iK2w386kfSzaoK0='
WHERE
key_id = '381adcd77919232e111d61a0a18727518655a5e0519221c21b379a41c73a31ba'
AND (
token = '/EC+IUiOEfi1I/fHINWboPAtubr3iK2w386kfSzaoK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)