UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U1zg/V3tMbhGLuQIC+hcRA7/wwGAbuezQU7k1ayXDsg='
WHERE
key_id = 'dc8e2732a25d974df618f59b94deac73272840e2170f759588c1ef15129eeb02'
AND (
token = 'U1zg/V3tMbhGLuQIC+hcRA7/wwGAbuezQU7k1ayXDsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)