UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvC9auHvt9VaUy19A1CL5yQ50iSiEErvh8gEwfZ4Yc4='
WHERE
key_id = '46199a3281c74f5dc47f138852c9b3d89caac71420e461e2a28415452ec5e463'
AND (
token = 'zvC9auHvt9VaUy19A1CL5yQ50iSiEErvh8gEwfZ4Yc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)