UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HbcAZjfDrHPvTYqrGLlR/QH7yqD8hM4zWT+qQ0+tt68='
WHERE
key_id = '237da02392786e6d385a2740eb70b7c402dc0c7df1575135b2e79394611951cf'
AND (
token = 'HbcAZjfDrHPvTYqrGLlR/QH7yqD8hM4zWT+qQ0+tt68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)